Create a role when first starting up the PostgreSQL DB


-- Login as postgres and Create DB, User

docker exec -it postgres-driver psql -U postgres
CREATE DATABASE driver;
CREATE USER adrian WITH ENCRYPTED PASSWORD 'password'

-- Check the users

\du

-- Grant privileges of DB driver to user and check DBs

GRANT ALL PRIVILEGES ON DATABASE driver TO adrian;
\l

-- Get Into DB

\c driver

-- Grant privileges of Tables and Sequences In Schema public to user

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO adrian;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO adrian;

-- Grant create of DB and Schema public to user

GRANT CREATE ON DATABASE driver TO adrian;
GRANT CREATE ON SCHEMA public TO adrian;
#docker #postgres






你可能感興趣的文章

Intersection Observer API 使用筆記

Intersection Observer API 使用筆記

理解與解決 N + 1 problem

理解與解決 N + 1 problem

利用 Elm 製作 Chrome Extension

利用 Elm 製作 Chrome Extension






留言討論